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