UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/naRIf5dxeQNIvdzn/TsGWSaHwRfopEqwFG+9AonNMs='
WHERE
key_id = 'b58b9a3cc28c143983f161b5371d1ea6da50bb494e63b2f903a03753eabddb41'
AND (
token = '/naRIf5dxeQNIvdzn/TsGWSaHwRfopEqwFG+9AonNMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)