UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KqYpqK8Pn7PdZ4HQEcVkyCQ5AiRGHL3Kn0Y82L4GBnw='
WHERE
key_id = 'ec70e789f04d1757ad5cdbfad882b6a4c582b67a369f347e673b91747c55d3b2'
AND (
token = 'KqYpqK8Pn7PdZ4HQEcVkyCQ5AiRGHL3Kn0Y82L4GBnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)