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