UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rwgh4zrVaUfvlg6M03UA8MByNwUPYKvNDqd5znu7tOs='
WHERE
key_id = 'b0c320c5c14c37646e5a6fa39f121f290099d6fedf9aac698d58595ef1f6ecce'
AND (
token = 'rwgh4zrVaUfvlg6M03UA8MByNwUPYKvNDqd5znu7tOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)