UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6BCUAOle8iC6yfnS/jducnBYrPvQPgoWVqv4fc186Sw='
WHERE
key_id = 'bfd856eb7be366b95913c1b5a6d146260ffc8d9777a382742026b860b385f0c3'
AND (
token = '6BCUAOle8iC6yfnS/jducnBYrPvQPgoWVqv4fc186Sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)