UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uYnVTj62z/lgwAoiIn9Msd0KSSb4zwcW2HvN3tlwe8E='
WHERE
key_id = 'b09a38ab2fb07c5b341f309ee9a91998f91b30205014d21f38076012466222d1'
AND (
token = 'uYnVTj62z/lgwAoiIn9Msd0KSSb4zwcW2HvN3tlwe8E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)