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