UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mMKfoK7kFieF3QvlM77w+nYRWbSTur7QOsxEgAoa9RY='
WHERE
key_id = '0fc00fa4a5e46e298a12ca7fafb7aa597078de2e34f1323ed0d8e3419244cf4a'
AND (
token = 'mMKfoK7kFieF3QvlM77w+nYRWbSTur7QOsxEgAoa9RY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)