UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9pL4RLSyDLY65DAUhpSNSC0czmJoTDbmFK552TRDUIc='
WHERE
key_id = '09baed667cf6d200425debd79a39b4decc3b87081102165b09314b0d2066f8d5'
AND (
token = '9pL4RLSyDLY65DAUhpSNSC0czmJoTDbmFK552TRDUIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)