UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3yA+hii+5M5rcf3QoJzFWfR0l6FKm+y3mKZBRrR+JO8='
WHERE
key_id = 'a9a9dafb0dcb3e60f9c7d5a576e14674597c6baf216f6d93cbc776683da93fce'
AND (
token = '3yA+hii+5M5rcf3QoJzFWfR0l6FKm+y3mKZBRrR+JO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)