UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e8uCIRDcyVDL1v/8DCCaTWEV5+/H96zicXaw+mimYf0='
WHERE
key_id = 'ed0dcc3d47f0b16e909076fa550f6a2add44aa3216fef4d47be4c0a6d521226a'
AND (
token = 'e8uCIRDcyVDL1v/8DCCaTWEV5+/H96zicXaw+mimYf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)