UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Y2oWPdlpYAmqIt8m4kuMsjWQuWso1Kz7muk/7lb3wc='
WHERE
key_id = '8178c60f1b55e22d6f1f3e85d3275464286128e8f870aeafc4ff670c72168cd6'
AND (
token = '8Y2oWPdlpYAmqIt8m4kuMsjWQuWso1Kz7muk/7lb3wc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)