UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qmn6ieE9Jc/4jh/58T2jd4v7aOwDrju0woIU3hE+gR8='
WHERE
key_id = 'f958f8a64a373c6363f1f6fb80f3ce04ebedb797ecee52167426f12fc515b7f9'
AND (
token = 'qmn6ieE9Jc/4jh/58T2jd4v7aOwDrju0woIU3hE+gR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)