UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p4WMWcYI1zqJ+MvIkaEz6ESFNEU+kQfO3oi35yexsIg='
WHERE
key_id = 'a327aea7a289d22a2c7b829f854240b5f9fe8c47b49ac8bc30fb5e17830caf60'
AND (
token = 'p4WMWcYI1zqJ+MvIkaEz6ESFNEU+kQfO3oi35yexsIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)