UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4xee1qPSRa0IwTSSzJkjPikk1yk/FYVLKGzF09pSusA='
WHERE
key_id = '0c83bcac78e1981c6579bbd16b81e9a8b9e3fb9f97c3acf363f598528c9d915f'
AND (
token = '4xee1qPSRa0IwTSSzJkjPikk1yk/FYVLKGzF09pSusA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)