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