UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sNOdVwGnLnEf56sd7FpsW/cAosXqVBrWemNyLqK/z6E='
WHERE
key_id = 'ac9d1a3e4e418dd1529eb7bf22c08e0b11e37efcc122f60fc504f041c425d894'
AND (
token = 'sNOdVwGnLnEf56sd7FpsW/cAosXqVBrWemNyLqK/z6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)