UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kgbCFu/G8dZxElyV1llP/QINiSA5ko1HG978loiG0gg='
WHERE
key_id = 'f15d2d6bf5c09d0a15a090019716f56bb1164bf3e133f211a528d3e5f1a71b7a'
AND (
token = 'kgbCFu/G8dZxElyV1llP/QINiSA5ko1HG978loiG0gg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)