UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mjXixKVnldvK5G05nrSFoeT8nYSsdUBUDgHgr2RIDL0='
WHERE
key_id = 'c462897ae7dbaf9c878aabb6d3ad6662b4b10f1fce09cec81d464ec1d44e57ce'
AND (
token = 'mjXixKVnldvK5G05nrSFoeT8nYSsdUBUDgHgr2RIDL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)