UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RBvT8CUwu17jTynHvoBhG4O4BniwnNG0El1iMsCZzac='
WHERE
key_id = '1ee58317517887d72c907565afba0996fe52bb68218d245ceae6b0ad0cfe1144'
AND (
token = 'RBvT8CUwu17jTynHvoBhG4O4BniwnNG0El1iMsCZzac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)