UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vxh9AFbYVmdGsaMn8wJ3SZNsJhRUf69jAsEAnXL8snI='
WHERE
key_id = '3267e727c955f525822cef5498fe63e332622bf460bb95f7ec75e1e07921a778'
AND (
token = 'vxh9AFbYVmdGsaMn8wJ3SZNsJhRUf69jAsEAnXL8snI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)