UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q66363gVF+35OSj2ULCnEV3hXVMsh5UE3lNfRzoQkqM='
WHERE
key_id = '138ba335f5c72146400424794ece080ab72fb1cf834585b895465b0ccc848f18'
AND (
token = 'q66363gVF+35OSj2ULCnEV3hXVMsh5UE3lNfRzoQkqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)