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