UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TZjf0KS/FvevGbvTKE9MMLYRu1hL5uzE3vFSeJW5xxc='
WHERE
key_id = '4e318122f0098644fe4b6556333b497823bdceec017f577995ac6aaa7a35b782'
AND (
token = 'TZjf0KS/FvevGbvTKE9MMLYRu1hL5uzE3vFSeJW5xxc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)