UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PTSxAqUhX9hteNMudDbHjRCqsqCPEg/afB7nQrcq6lA='
WHERE
key_id = 'ac8d5928d9d40dcc96b76848506c5973eeb6acc0140b86d38522f9a521da0252'
AND (
token = 'PTSxAqUhX9hteNMudDbHjRCqsqCPEg/afB7nQrcq6lA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)