UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ts749Gg+BONPIg7n3yqesJ8QUBQKfZuIvCJ5j/GNRsE='
WHERE
key_id = 'ae2542ff9f3a6249c87fc80cd97b84c37b0b4f2ddb69c52c78c1604a43b17454'
AND (
token = 'Ts749Gg+BONPIg7n3yqesJ8QUBQKfZuIvCJ5j/GNRsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)