UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AfYqZni3+B95T0XCRS+6z6nsr7bOc68G6r3e/JVRYy4='
WHERE
key_id = 'b608a5f0f486df36b8fd42bb8865e1ebe830e7e41e1ebc936ae42c1ed41ace21'
AND (
token = 'AfYqZni3+B95T0XCRS+6z6nsr7bOc68G6r3e/JVRYy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)