UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N/7amdtP2XLATx5zOThEXLii6np/q4ssa4CqlWWGyU0='
WHERE
key_id = 'ec476d9b3695944086f9dac4f88d0059ac06595de4d37797cb2e010c57853fd4'
AND (
token = 'N/7amdtP2XLATx5zOThEXLii6np/q4ssa4CqlWWGyU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)