UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HAmh/R4QgvYsge5kY7Prcmlgc5tOAgqZTV640j8EoLA='
WHERE
key_id = '0f6b6e6a5e0e96449f3db04a02f41d75414690ae0c246f532b5e9de3c928e5cd'
AND (
token = 'HAmh/R4QgvYsge5kY7Prcmlgc5tOAgqZTV640j8EoLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)