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