UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9pgBM7d3QdMpW1lZS6ua6ykeCsC6keOlnSeg7h7Vu5s='
WHERE
key_id = 'c198b7b3e973805bf345a446576df7e2fbc096dca67a201ffe4657b0d4e83d0c'
AND (
token = '9pgBM7d3QdMpW1lZS6ua6ykeCsC6keOlnSeg7h7Vu5s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)