UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ge6+rPquQk0I4YLSq12g+fUZPIsI8+N029+r31SZd8w='
WHERE
key_id = 'd3d9e7e6350f92f7377d49df8d2c6ed81e4fdabbf9e68c234f7b6ca1ce193340'
AND (
token = 'Ge6+rPquQk0I4YLSq12g+fUZPIsI8+N029+r31SZd8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)