UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sHBDT/VoRLhIRVH4irVXsq87a2DZLLj5iJW1h2BVQLE='
WHERE
key_id = 'f78f2dd7e470a62bc8759dc9f4b75448c3da9fbeb5b45e491373460266515502'
AND (
token = 'sHBDT/VoRLhIRVH4irVXsq87a2DZLLj5iJW1h2BVQLE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)