UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4lN/KsOZFQCwoX4zlMDarmwWZc8LQWHa7Fj4N2U3KI8='
WHERE
key_id = '5a304cae59fd17a566c585c821c891f63855df17a3f10af4a9ada9d5c12092d8'
AND (
token = '4lN/KsOZFQCwoX4zlMDarmwWZc8LQWHa7Fj4N2U3KI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)