UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G2m1Ta69m+7x+ZCy727NfVH09mkKZh1eF0YJfOEPQ1c='
WHERE
key_id = 'f634b16942672b0f2a75d15375ae330196755eed63b866df354022be803d4fdb'
AND (
token = 'G2m1Ta69m+7x+ZCy727NfVH09mkKZh1eF0YJfOEPQ1c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)